package epsi.mobile.constants;

//Contain Constants of Store in SQL 
public class StoreSQLConstants {
	
	// Name of base
	public static final String TABLE_NAME_STORE = "Store";
	
	// Name of column
	public static final String COL_STOREID = "ID";
	public static final String COL_STORENAME = "Name";
	public static final String COL_ADRESS = "Adress";
	public static final String COL_POSTALCODE = "PostalCode";
	public static final String COL_CITY = "City";
	public static final String COL_PHONENUMBER = "PhoneNumber";
	public static final String COL_TIMETABLE = "TimeTable";
	public static final String COL_FAX = "Fax";
	public static final String COL_XPOSITION = "Xposition";
	public static final String COL_YPOSITION = "Yposition";
	
	// Number of column
	public static final int NUM_COL_STOREID = 0;
	public static final int NUM_COL_STORENAME = 1;
	public static final int NUM_COL_ADRESS = 2;
	public static final int NUM_COL_POSTALCODE = 3;
	public static final int NUM_COL_CITY = 4;
	public static final int NUM_COL_PHONENUMBER = 5;
	public static final int NUM_COL_TIMETABLE = 6;
	public static final int NUM_COL_FAX = 7;
	public static final int NUM_COL_XPOSITION = 8;
	public static final int NUM_COL_YPOSITION = 9;
	
	// Query to create the base of store
	public static final String TABLE_CREATEREQUEST_STORE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME_STORE + " ("
	+ COL_STOREID + " TEXT PRIMARY KEY, " 
    + COL_STORENAME + " TEXT NOT NULL, "
	+ COL_ADRESS + " TEXT," 
	+ COL_POSTALCODE + " INTEGER NOT NULL, "
	+ COL_CITY + " TEXT, "
	+ COL_PHONENUMBER + " TEXT, "
	+ COL_TIMETABLE + " TEXT, "
    + COL_FAX + " TEXT, "
	+ COL_XPOSITION + " REAL, "
	+ COL_YPOSITION + " REAL"
    + ");";
	

}
